package com.yf.mapper;

import com.yf.bean.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author : hzyao
 * @date : 16:36 2020/10/7
 */
@Mapper
public interface ljxMapper {
//    查询8代
    @Select("select * from ljx8 where CH8=#{ch8}")
    ljx8 getByLevel8(@Param("ch8") String ch8);
//    查询7代
    @Select("select * from ljx7 where LH7=#{lh7}")
    ljx7 getByLevel7(@Param("lh7") String lh7);
//    查询6代
    @Select("select * from ljx6 where LH6=#{lh6}")
    ljx6 getByLevel6(@Param("lh6") String lh6);
//    查询5代
    @Select("select * from ljx5 where LH5=#{lh5}")
    ljx5 getByLevel5(String lh5);
//    查询4代
    @Select("select * from ljx4 where LH4=#{lh4}")
    ljx4 getByLevel4(String lh4);
//    查询3代
    @Select("select * from ljx3 where LH3=#{lh3}")
    ljx3 getByLevel3(String lh3);

}
